<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Jialeo\LaravelSchemaExtend\Schema;

class AlterOpenShopSiteLocations extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('open_shop_site_locations', function (Blueprint $table) {
            //工程条件
            $table->string('doorWidth', 7)->default('')->change();
            $table->string('shopWidth', 7)->default('')->change();
            $table->string('floorHeight', 7)->default('')->change();
            $table->string('depth', 7)->default('')->change();
            $table->string('area', 7)->default('')->change();
            $table->string('electricityConsumption', 7)->default('')->change();
            $table->string('capacityIncreaseFee', 7)->default('')->change();
            $table->string('exhaustAirVolume', 7)->default('')->change();
            $table->string('upperWaterDiameter', 7)->default('')->change();
            $table->string('lowerWaterDiameter', 7)->default('')->change();
            $table->string('adSpaceNumber', 7)->default('')->change();

            //商务条件
            $table->string('deposit', 7)->default('')->change();
            $table->string('leaseTerm', 7)->default('')->change();
            $table->string('rentFreePeriod', 7)->default('')->change();
            $table->string('waterFee', 7)->default('100')->change();
            $table->string('electricityFee', 7)->default('1200')->change();
            $table->string('propertyFee', 7)->default('')->change();
            $table->string('mobilizationFee', 7)->default('')->change();
            $table->string('bond', 7)->default('')->change();
            $table->string('manageFee', 7)->default('')->change();
            $table->string('sponsorshipFee', 7)->default('')->change();
            $table->string('promotionFee', 7)->default('')->change();
            $table->string('otherFee', 7)->default('')->change();

            //投资预算
            $table->string('foodstuffMarginRate', 7)->default('65')->change();
            $table->string('shopAssistantMonthSalary', 7)->default('')->change();
            $table->string('shopAssistantCount', 7)->default('')->change();
            $table->string('shopManagerMonthSalary', 7)->default('')->change();
            $table->string('shopManagerCount', 7)->default('')->change();
            $table->string('electricityFeeMonth', 7)->default('')->change();
            $table->string('waterFeeMonth', 7)->default('')->change();


        });

        Schema::table('open_shop_site_location_product_analysis', function (Blueprint $table) {
            $table->string('hallFoodNumber', 7)->default('')->change();
            $table->string('hallFoodUnitPrice', 7)->default('')->change();
            $table->string('elemNumber', 7)->default('')->change();
            $table->string('elemUnitPrice', 7)->default('')->change();
            $table->string('meituanNumber', 7)->default('')->change();
            $table->string('meituanUnitPrice', 7)->default('')->change();
        });

        Schema::table('open_shop_site_location_customer_analysis', function (Blueprint $table) {
            $table->string('afternoonNumber', 7)->default('')->change();
            $table->string('afternoonYoungProportion', 7)->default('')->change();
            $table->string('afternoonTeaNumber', 7)->default('')->change();
            $table->string('afternoonTeaYoungProportion', 7)->default('')->change();
            $table->string('nightNumber', 7)->default('')->change();
            $table->string('nightYoungProportion', 7)->default('')->change();
            $table->string('nightSnackNumber', 7)->default('')->change();
            $table->string('nightSnackYoungProportion', 7)->default('')->change();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
